﻿using FluentMigrator;
using System;
using System.Collections.Generic;
using System.Text;

namespace Comteck.MigratorCenter.Versions._2025 {
  /// <summary>
  /// 
  /// </summary>
  [Migration(202504180001)]
  public class _202504180001 : Migration {
    /// <summary>
    /// Up
    /// </summary>
    public override void Up() {
      this.Execute.Sql(@"

create table cc_bin_goods_order_type (
   id                   integer                 not null,
   name                 text          null,
   status            integer         not null,
   seq_no               integer                 null,
   description          text         null
);

");

      this.Execute.Sql(@"

create table cc_bin_goods_order_status (
   id                   integer                 not null,
   name                 text          null,
   status            integer         not null,
   seq_no               integer                 null,
   description          text         null
);

");


      this.Execute.Sql(@"

create table cc_bin_goods_sum_status (
   id                   integer                 not null,
   name                 text          null,
   status            integer         not null,
   seq_no               integer                 null,
   description          text         null
);

");


      this.Execute.Sql(@"

create table cc_sale_sorting_order_status (
   id                   integer                 not null,
   name                 text          null,
   status            integer         not null,
   seq_no               integer                 null,
   description          text         null
);

");


      this.Execute.Sql(@"

create table cc_sale_sorting_order_type (
   id                   integer                 not null,
   name                 text          null,
   status            integer         not null,
   seq_no               integer                 null,
   description          text         null
);

");


    }

    /// <summary>
    /// 
    /// </summary>
    public override void Down() {
      this.Delete.Table("cc_bin_goods_order_type");
      this.Delete.Table("cc_bin_goods_order_status");
      this.Delete.Table("cc_bin_goods_sum_status");
      this.Delete.Table("cc_sale_sorting_order_status");
      this.Delete.Table("cc_sale_sorting_order_type");
    }

  }
}
